package kr.or.kosta.otr.persistence.board;

import java.sql.SQLException;
import java.util.ArrayList;

import kr.or.kosta.otr.vo.BoardVO;

public interface BoardDao {
	int writeBoard(BoardVO vo) throws SQLException;
	void updateBoard(BoardVO vo) throws SQLException;
	void updateHits(int boardId) throws SQLException;
	void deleteBoard(int boardId) throws SQLException;
	BoardVO getOneBoardById(int boardId) throws SQLException;
	int getTotalCount() throws SQLException;
	ArrayList<BoardVO> getBoardListByPage(int pageNo) throws SQLException;
	ArrayList<BoardVO> getBoardByUserId(String userId) throws SQLException;
	ArrayList<BoardVO> getBoardByTitle(String title) throws SQLException;
	ArrayList<BoardVO> getBoardByContent(String content) throws SQLException;
}
